package com.mxpio.erp.common.workshop.entity;

import com.mxpioframework.jpa.annotation.Generator;
import com.mxpioframework.jpa.policy.impl.UUIDPolicy;
import com.mxpioframework.security.entity.BaseEntity;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;
import lombok.EqualsAndHashCode;

import javax.persistence.*;
import java.math.BigDecimal;

/**
 * 生产订单齐套分析
 */
@Data
@EqualsAndHashCode(callSuper=false)
@Entity
@Table(name = "MB_ERP_WORKSHOP_MO_MKA_HIS")
@Schema(description="生产订单齐套分析记录")
public class MaterialKittingAnalysisHistory extends BaseEntity {

    private static final long serialVersionUID = 1L;
    /**工序编码*/
    @Id
    @Column(name = "ID_", updatable = false)
    @Generator(policy = UUIDPolicy.class)
    @Schema(description = "主键")
    private String id;

    @Column(name = "MO_BIZ_NOS_")
    @Schema(description = "分析的生产订单单号，以逗号分隔")
    private String moBizNos;

    @Column(name = "ANALYSIS_PERIOD_")
    @Schema(description = "分析周期")
    private String analysisPeriod;

    @Column(name = "ALL_CNT_SEVEN_")
    @Schema(description = "七天订单数量")
    private BigDecimal allCntSeven;

    @Column(name = "KITTING_CNT_SEVEN_")
    @Schema(description = "七天订单齐套数量")
    private BigDecimal kittingCntSeven;

    @Column(name = "KITTING_PERCENT_SEVEN_")
    @Schema(description = "七天订单齐套率(%)")
    private BigDecimal kittingPercentSeven;

    @Column(name = "ALL_CNT_THREE_")
    @Schema(description = "三天订单数量")
    private BigDecimal allCntThree;

    @Column(name = "KITTING_CNT_THREE_")
    @Schema(description = "三天订单齐套数量")
    private BigDecimal kittingCntThree;

    @Column(name = "KITTING_PERCENT_THREE_")
    @Schema(description = "三天订单齐套率(%)")
    private BigDecimal kittingPercentThree;

    @Column(name = "ALL_CNT_ONE_")
    @Schema(description = "一天订单数量")
    private BigDecimal allCntOne;

    @Column(name = "KITTING_CNT_ONE_")
    @Schema(description = "一天订单齐套数量")
    private BigDecimal kittingCntOne;

    @Column(name = "KITTING_PERCENT_ONE_")
    @Schema(description = "一天订单齐套率(%)")
    private BigDecimal kittingPercentOne;

}
